package com.csc.mapper;

import com.csc.entity.Employees;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
* @author 30978
* @description 针对表【employees(员工基本信息表)】的数据库操作Mapper
* @createDate 2025-05-30 08:39:22
* @Entity com.csc.entity.Employees
*/
public interface EmployeesMapper {

    int deleteByPrimaryKey(Long id);


    int insertSelective(Employees record);

    Employees selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Employees record);

    int updateByPrimaryKey(Employees record);
    //查询所有员工数
    int countAllEmployees();
    //根据工号查询员工+社保
    Employees selectEmployeeWithInsuranceByNo(String employeeNo);
    //根据员工姓名/部门id查询员工
    List<Employees> selectByCondition(
            @Param("name") String name,
            @Param("departmentId") Integer departmentId
    );
    //根据工号查询员工+考勤
    Employees selectEmployeeWithAttendancesByNo(String employeeNo);

}
